Pandas Profiling Report

Dataset statistics

Number of variables	12
Number of observations	5680
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	532.6 KiB
Average record size in memory	96.0 B

Variable types

Numeric	12

Alerts

`df_index` is highly correlated with `customer_id` and 2 other fields	High correlation
`gross_revenue` is highly correlated with `purchases_quantity` and 4 other fields	High correlation
`recency_days` is highly correlated with `df_index` and 2 other fields	High correlation
`purchases_quantity` is highly correlated with `gross_revenue` and 4 other fields	High correlation
`basket_size` is highly correlated with `gross_revenue` and 4 other fields	High correlation
`qt_products` is highly correlated with `gross_revenue` and 3 other fields	High correlation
`max_recency` is highly correlated with `df_index` and 2 other fields	High correlation
`qt_returns` is highly correlated with `gross_revenue` and 4 other fields	High correlation
`purchased_returned_diff` is highly correlated with `gross_revenue` and 2 other fields	High correlation
`frequency` is highly correlated with `purchases_quantity`	High correlation
`customer_id` is highly correlated with `df_index` and 2 other fields	High correlation
`avg_ticket` is highly correlated with `qt_returns`	High correlation
`gross_revenue` is highly skewed (γ1 = 23.01864323)	Skewed
`basket_size` is highly skewed (γ1 = 25.07383309)	Skewed
`avg_ticket` is highly skewed (γ1 = 48.13887319)	Skewed
`qt_returns` is highly skewed (γ1 = 29.86213869)	Skewed
`df_index` is uniformly distributed	Uniform
`df_index` has unique values	Unique
`customer_id` has unique values	Unique
`qt_returns` has 4190 (73.8%) zeros	Zeros
`purchased_returned_diff` has 115 (2.0%) zeros	Zeros

Reproduction

Analysis started	2022-11-18 03:02:04.449903
Analysis finished	2022-11-18 03:02:39.155706
Duration	34.71 seconds
Software version	pandas-profiling v3.4.0
Download configuration	config.json

df_index
Real number (ℝ_≥0)

HIGH CORRELATION
UNIFORM
UNIQUE

Distinct	5680
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2888.285387

Minimum	0
Maximum	5770
Zeros	1
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	44.5 KiB

Quantile statistics

Minimum	0
5-th percentile	288.95
Q1	1450.75
median	2890.5
Q3	4329.25
95-th percentile	5480.05
Maximum	5770
Range	5770
Interquartile range (IQR)	2878.5

Descriptive statistics

Standard deviation	1664.584059
Coefficient of variation (CV)	0.5763225707
Kurtosis	-1.196205237
Mean	2888.285387
Median Absolute Deviation (MAD)	1439.5
Skewness	-0.003560571232
Sum	16405461
Variance	2770840.091
Monotonicity	Strictly increasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	1	< 0.1%
3879	1	< 0.1%
3855	1	< 0.1%
3854	1	< 0.1%
3853	1	< 0.1%
3852	1	< 0.1%
3851	1	< 0.1%
3850	1	< 0.1%
3849	1	< 0.1%
3848	1	< 0.1%
Other values (5670)	5670	99.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1	< 0.1%
1	1	< 0.1%
2	1	< 0.1%
3	1	< 0.1%
4	1	< 0.1%
5	1	< 0.1%
6	1	< 0.1%
7	1	< 0.1%
8	1	< 0.1%
9	1	< 0.1%

Value	Count	Frequency (%)
5770	1	< 0.1%
5769	1	< 0.1%
5768	1	< 0.1%
5767	1	< 0.1%
5766	1	< 0.1%
5765	1	< 0.1%
5764	1	< 0.1%
5763	1	< 0.1%
5762	1	< 0.1%
5761	1	< 0.1%

customer_id
Real number (ℝ_≥0)

HIGH CORRELATION
UNIQUE

Distinct	5680
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	16433.86796

Minimum	12347
Maximum	21997
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	44.5 KiB

Quantile statistics

Minimum	12347
5-th percentile	12702.95
Q1	14291.75
median	16231
Q3	18212.25
95-th percentile	21031.2
Maximum	21997
Range	9650
Interquartile range (IQR)	3920.5

Descriptive statistics

Standard deviation	2563.32051
Coefficient of variation (CV)	0.1559779181
Kurtosis	-0.8653935729
Mean	16433.86796
Median Absolute Deviation (MAD)	1960
Skewness	0.3123861003
Sum	93344370
Variance	6570612.038
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
17850	1	< 0.1%
15007	1	< 0.1%
20375	1	< 0.1%
20374	1	< 0.1%
15578	1	< 0.1%
12424	1	< 0.1%
20372	1	< 0.1%
17837	1	< 0.1%
20369	1	< 0.1%
14327	1	< 0.1%
Other values (5670)	5670	99.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
12347	1	< 0.1%
12348	1	< 0.1%
12349	1	< 0.1%
12350	1	< 0.1%
12352	1	< 0.1%
12353	1	< 0.1%
12354	1	< 0.1%
12355	1	< 0.1%
12356	1	< 0.1%
12357	1	< 0.1%

Value	Count	Frequency (%)
21997	1	< 0.1%
21996	1	< 0.1%
21995	1	< 0.1%
21994	1	< 0.1%
21993	1	< 0.1%
21992	1	< 0.1%
21988	1	< 0.1%
21987	1	< 0.1%
21984	1	< 0.1%
21983	1	< 0.1%

gross_revenue
Real number (ℝ_≥0)

HIGH CORRELATION
SKEWED

Distinct	5438
Distinct (%)	95.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1762.764634

Minimum	0.42
Maximum	279138.02
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	44.5 KiB

Quantile statistics

Minimum	0.42
5-th percentile	13.3735
Q1	237.2875
median	613.93
Q3	1571.07
95-th percentile	5307.991
Maximum	279138.02
Range	279137.6
Interquartile range (IQR)	1333.7825

Descriptive statistics

Standard deviation	7510.45918
Coefficient of variation (CV)	4.260613718
Kurtosis	699.5570111
Mean	1762.764634
Median Absolute Deviation (MAD)	479.46
Skewness	23.01864323
Sum	10012503.12
Variance	56406997.1
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
7.95	9	0.2%
4.95	8	0.1%
1.25	8	0.1%
2.95	8	0.1%
3.75	7	0.1%
1.65	7	0.1%
12.75	7	0.1%
5.95	6	0.1%
4.25	6	0.1%
7.5	6	0.1%
Other values (5428)	5608	98.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.42	1	< 0.1%
0.65	1	< 0.1%
0.79	1	< 0.1%
0.84	4	0.1%
0.85	3	0.1%
1.07	1	< 0.1%
1.25	8	0.1%
1.44	1	< 0.1%
1.65	7	0.1%
1.69	1	< 0.1%

Value	Count	Frequency (%)
279138.02	1	< 0.1%
259657.3	1	< 0.1%
194550.79	1	< 0.1%
136275.72	1	< 0.1%
124564.53	1	< 0.1%
116729.63	1	< 0.1%
91062.38	1	< 0.1%
72882.09	1	< 0.1%
66653.56	1	< 0.1%
65039.62	1	< 0.1%

recency_days
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	304
Distinct (%)	5.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	116.8264085

Minimum	0
Maximum	373
Zeros	37
Zeros (%)	0.7%
Negative	0
Negative (%)	0.0%
Memory size	44.5 KiB

Quantile statistics

Minimum	0
5-th percentile	3
Q1	22
median	71
Q3	199.25
95-th percentile	338
Maximum	373
Range	373
Interquartile range (IQR)	177.25

Descriptive statistics

Standard deviation	111.6124711
Coefficient of variation (CV)	0.9553702158
Kurtosis	-0.640424192
Mean	116.8264085
Median Absolute Deviation (MAD)	61
Skewness	0.8152565497
Sum	663574
Variance	12457.34369
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	110	1.9%
4	105	1.8%
3	98	1.7%
2	92	1.6%
10	86	1.5%
8	82	1.4%
17	79	1.4%
9	79	1.4%
7	77	1.4%
15	66	1.2%
Other values (294)	4806	84.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	37	0.7%
1	110	1.9%
2	92	1.6%
3	98	1.7%
4	105	1.8%
5	52	0.9%
7	77	1.4%
8	82	1.4%
9	79	1.4%
10	86	1.5%

Value	Count	Frequency (%)
373	23	0.4%
372	22	0.4%
371	17	0.3%
369	4	0.1%
368	13	0.2%
367	16	0.3%
366	15	0.3%
365	19	0.3%
364	11	0.2%
362	7	0.1%

purchases_quantity
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	57
Distinct (%)	1.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3.47693662

Minimum	1
Maximum	206
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	44.5 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	1
Q3	4
95-th percentile	11
Maximum	206
Range	205
Interquartile range (IQR)	3

Descriptive statistics

Standard deviation	6.81469284
Coefficient of variation (CV)	1.959970395
Kurtosis	300.1339365
Mean	3.47693662
Median Absolute Deviation (MAD)	0
Skewness	13.14920397
Sum	19749
Variance	46.44003851
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	2858	50.3%
2	823	14.5%
3	503	8.9%
4	394	6.9%
5	237	4.2%
6	173	3.0%
7	138	2.4%
8	98	1.7%
9	70	1.2%
11	54	1.0%
Other values (47)	332	5.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	2858	50.3%
2	823	14.5%
3	503	8.9%
4	394	6.9%
5	237	4.2%
6	173	3.0%
7	138	2.4%
8	98	1.7%
9	70	1.2%
10	54	1.0%

Value	Count	Frequency (%)
206	1	< 0.1%
198	1	< 0.1%
124	1	< 0.1%
97	1	< 0.1%
91	2	< 0.1%
86	1	< 0.1%
72	1	< 0.1%
62	2	< 0.1%
60	1	< 0.1%
57	1	< 0.1%

basket_size
Real number (ℝ_≥0)

HIGH CORRELATION
SKEWED

Distinct	1841
Distinct (%)	32.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	953.1683099

Minimum	1
Maximum	196844
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	44.5 KiB

Quantile statistics

Minimum	1
5-th percentile	4.95
Q1	106
median	317.5
Q3	805.25
95-th percentile	2927.8
Maximum	196844
Range	196843
Interquartile range (IQR)	699.25

Descriptive statistics

Standard deviation	4194.233908
Coefficient of variation (CV)	4.400307757
Kurtosis	940.6390595
Mean	953.1683099
Median Absolute Deviation (MAD)	253.5
Skewness	25.07383309
Sum	5413996
Variance	17591598.07
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	114	2.0%
2	70	1.2%
3	51	0.9%
4	49	0.9%
5	35	0.6%
6	29	0.5%
12	24	0.4%
72	21	0.4%
88	21	0.4%
7	20	0.4%
Other values (1831)	5246	92.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	114	2.0%
2	70	1.2%
3	51	0.9%
4	49	0.9%
5	35	0.6%
6	29	0.5%
7	20	0.4%
8	18	0.3%
9	7	0.1%
10	17	0.3%

Value	Count	Frequency (%)
196844	1	< 0.1%
80179	1	< 0.1%
77373	1	< 0.1%
69993	1	< 0.1%
64549	1	< 0.1%
64124	1	< 0.1%
63312	1	< 0.1%
58343	1	< 0.1%
57872	1	< 0.1%
50255	1	< 0.1%

qt_products
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	529
Distinct (%)	9.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	92.79137324

Minimum	1
Maximum	7838
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	44.5 KiB

Quantile statistics

Minimum	1
5-th percentile	2
Q1	14
median	41
Q3	107
95-th percentile	333
Maximum	7838
Range	7837
Interquartile range (IQR)	93

Descriptive statistics

Standard deviation	210.4125806
Coefficient of variation (CV)	2.267587743
Kurtosis	508.0725752
Mean	92.79137324
Median Absolute Deviation (MAD)	33
Skewness	17.6926127
Sum	527055
Variance	44273.45409
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	254	4.5%
2	147	2.6%
3	108	1.9%
10	100	1.8%
6	98	1.7%
9	92	1.6%
5	90	1.6%
4	86	1.5%
7	83	1.5%
13	81	1.4%
Other values (519)	4541	79.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	254	4.5%
2	147	2.6%
3	108	1.9%
4	86	1.5%
5	90	1.6%
6	98	1.7%
7	83	1.5%
8	80	1.4%
9	92	1.6%
10	100	1.8%

Value	Count	Frequency (%)
7838	1	< 0.1%
5589	1	< 0.1%
5095	1	< 0.1%
4580	1	< 0.1%
2698	1	< 0.1%
2379	1	< 0.1%
2060	1	< 0.1%
1818	1	< 0.1%
1673	1	< 0.1%
1637	1	< 0.1%

avg_ticket
Real number (ℝ_≥0)

HIGH CORRELATION
SKEWED

Distinct	5489
Distinct (%)	96.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	31.17597255

Minimum	0.42
Maximum	13305.5
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	44.5 KiB

Quantile statistics

Minimum	0.42
5-th percentile	3.460929841
Q1	7.948445596
median	15.83608609
Q3	21.9193109
95-th percentile	75.94814286
Maximum	13305.5
Range	13305.08
Interquartile range (IQR)	13.9708653

Descriptive statistics

Standard deviation	210.7379503
Coefficient of variation (CV)	6.759627143
Kurtosis	2843.811943
Mean	31.17597255
Median Absolute Deviation (MAD)	7.466538718
Skewness	48.13887319
Sum	177079.5241
Variance	44410.48369
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
3.75	11	0.2%
4.95	10	0.2%
1.25	9	0.2%
2.95	9	0.2%
7.95	8	0.1%
12.75	7	0.1%
1.65	7	0.1%
8.25	7	0.1%
5.95	6	0.1%
4.15	6	0.1%
Other values (5479)	5600	98.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.42	3	0.1%
0.535	1	< 0.1%
0.65	1	< 0.1%
0.79	1	< 0.1%
0.8371428571	1	< 0.1%
0.84	2	< 0.1%
0.85	3	0.1%
1.002222222	1	< 0.1%
1.02	1	< 0.1%
1.03875	1	< 0.1%

Value	Count	Frequency (%)
13305.5	1	< 0.1%
4453.43	1	< 0.1%
3861	1	< 0.1%
3202.92	1	< 0.1%
3096	1	< 0.1%
1687.2	1	< 0.1%
1377.077778	1	< 0.1%
1001.2	1	< 0.1%
952.9875	1	< 0.1%
931.5	1	< 0.1%

max_recency
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	365
Distinct (%)	6.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	152.5357394

Minimum	0
Maximum	373
Zeros	4
Zeros (%)	0.1%
Negative	0
Negative (%)	0.0%
Memory size	44.5 KiB

Quantile statistics

Minimum	0
5-th percentile	21
Q1	67.75
median	135
Q3	225
95-th percentile	351
Maximum	373
Range	373
Interquartile range (IQR)	157.25

Descriptive statistics

Standard deviation	100.2286827
Coefficient of variation (CV)	0.6570832713
Kurtosis	-0.7720747076
Mean	152.5357394
Median Absolute Deviation (MAD)	75
Skewness	0.5151050787
Sum	866403
Variance	10045.78883
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
154	44	0.8%
63	43	0.8%
213	40	0.7%
42	37	0.7%
64	35	0.6%
53	35	0.6%
101	35	0.6%
50	34	0.6%
119	34	0.6%
35	33	0.6%
Other values (355)	5310	93.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	4	0.1%
1	11	0.2%
2	7	0.1%
3	13	0.2%
4	18	0.3%
5	10	0.2%
7	14	0.2%
8	7	0.1%
9	16	0.3%
10	23	0.4%

Value	Count	Frequency (%)
373	23	0.4%
372	22	0.4%
371	17	0.3%
369	4	0.1%
368	13	0.2%
367	16	0.3%
366	16	0.3%
365	20	0.4%
364	12	0.2%
363	1	< 0.1%

qt_returns
Real number (ℝ_≥0)

HIGH CORRELATION
SKEWED
ZEROS

Distinct	206
Distinct (%)	3.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	19.0931338

Minimum	0
Maximum	9360
Zeros	4190
Zeros (%)	73.8%
Negative	0
Negative (%)	0.0%
Memory size	44.5 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	1
95-th percentile	38
Maximum	9360
Range	9360
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	238.4156455
Coefficient of variation (CV)	12.48698343
Kurtosis	1036.930505
Mean	19.0931338
Median Absolute Deviation (MAD)	0
Skewness	29.86213869
Sum	108449
Variance	56842.02003
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	4190	73.8%
1	169	3.0%
2	148	2.6%
3	105	1.8%
4	89	1.6%
6	78	1.4%
5	61	1.1%
12	51	0.9%
7	44	0.8%
8	43	0.8%
Other values (196)	702	12.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	4190	73.8%
1	169	3.0%
2	148	2.6%
3	105	1.8%
4	89	1.6%
5	61	1.1%
6	78	1.4%
7	44	0.8%
8	43	0.8%
9	41	0.7%

Value	Count	Frequency (%)
9360	1	< 0.1%
9014	1	< 0.1%
8004	1	< 0.1%
4427	1	< 0.1%
3768	1	< 0.1%
3331	1	< 0.1%
2878	1	< 0.1%
2022	1	< 0.1%
2012	1	< 0.1%
1776	1	< 0.1%

purchased_returned_diff
Real number (ℝ_≥0)

HIGH CORRELATION
ZEROS

Distinct	1851
Distinct (%)	32.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	5.50240829

Minimum	0
Maximum	12.18870266
Zeros	115
Zeros (%)	2.0%
Negative	0
Negative (%)	0.0%
Memory size	44.5 KiB

Quantile statistics

Minimum	0
5-th percentile	1.386294361
Q1	4.65396035
median	5.749392986
Q3	6.682421685
95-th percentile	7.960323629
Maximum	12.18870266
Range	12.18870266
Interquartile range (IQR)	2.028461334

Descriptive statistics

Standard deviation	1.830438717
Coefficient of variation (CV)	0.3326613766
Kurtosis	1.184339164
Mean	5.50240829
Median Absolute Deviation (MAD)	1.005418397
Skewness	-0.8326079357
Sum	31253.67909
Variance	3.350505896
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	115	2.0%
0.6931471806	70	1.2%
1.098612289	51	0.9%
1.386294361	49	0.9%
1.609437912	35	0.6%
1.791759469	29	0.5%
2.48490665	24	0.4%
4.477336814	22	0.4%
4.276666119	22	0.4%
1.945910149	20	0.4%
Other values (1841)	5243	92.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	115	2.0%
0.6931471806	70	1.2%
1.098612289	51	0.9%
1.386294361	49	0.9%
1.609437912	35	0.6%
1.791759469	29	0.5%
1.945910149	20	0.4%
2.079441542	18	0.3%
2.197224577	7	0.1%
2.302585093	17	0.3%

Value	Count	Frequency (%)
12.18870266	1	< 0.1%
11.25085916	1	< 0.1%
11.24958472	1	< 0.1%
11.14245581	1	< 0.1%
11.06857399	1	< 0.1%
11.0511122	1	< 0.1%
11.03178808	1	< 0.1%
10.96856029	1	< 0.1%
10.95103459	1	< 0.1%
10.8075235	1	< 0.1%

frequency
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	1225
Distinct (%)	21.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.5464364876

Minimum	0.005449591281
Maximum	17
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	44.5 KiB

Quantile statistics

Minimum	0.005449591281
5-th percentile	0.01102941176
Q1	0.02491103203
median	1
Q3	1
95-th percentile	1
Maximum	17
Range	16.99455041
Interquartile range (IQR)	0.975088968

Descriptive statistics

Standard deviation	0.5504765781
Coefficient of variation (CV)	1.007393523
Kurtosis	139.3150778
Mean	0.5464364876
Median Absolute Deviation (MAD)	0
Skewness	4.869349083
Sum	3103.759249
Variance	0.303024463
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	2866	50.5%
2	47	0.8%
0.0625	17	0.3%
0.02777777778	17	0.3%
0.02380952381	16	0.3%
0.08333333333	15	0.3%
0.09090909091	15	0.3%
0.02941176471	14	0.2%
0.03448275862	14	0.2%
0.02127659574	13	0.2%
Other values (1215)	2646	46.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.005449591281	1	< 0.1%
0.005464480874	1	< 0.1%
0.005479452055	1	< 0.1%
0.005494505495	1	< 0.1%
0.005586592179	2	< 0.1%
0.005602240896	1	< 0.1%
0.005617977528	2	< 0.1%
0.00566572238	1	< 0.1%
0.005681818182	2	< 0.1%
0.005698005698	3	0.1%

Value	Count	Frequency (%)
17	1	< 0.1%
4	1	< 0.1%
3	5	0.1%
2	47	0.8%
1.142857143	1	< 0.1%
1	2866	50.5%
0.75	1	< 0.1%
0.6666666667	3	0.1%
0.550802139	1	< 0.1%
0.5308310992	1	< 0.1%

Auto

The auto setting is an easily interpretable pairwise column metric of the following mapping: vartype-vartype : method, categorical-categorical : Cramer's V, numerical-categorical : Cramer's V (using a discretized numerical column), numerical-numerical : Spearman's ρ. This configuration uses the best suitable for each pair of columns.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows

	df_index	customer_id	gross_revenue	recency_days	purchases_quantity	basket_size	qt_products	avg_ticket	max_recency	qt_returns	purchased_returned_diff	frequency
0	0	17850	5391.21000	372.00000	34.00000	1733.00000	297.00000	18.15222	372.00000	40.00000	7.43426	17.00000
1	1	13047	3232.59000	56.00000	9.00000	1390.00000	171.00000	18.90404	71.00000	35.00000	7.21156	0.02830
2	2	12583	6705.38000	2.00000	15.00000	5028.00000	232.00000	28.90250	73.00000	50.00000	8.51278	0.04032
3	3	13748	948.25000	95.00000	5.00000	439.00000	28.00000	33.86607	137.00000	0.00000	6.08450	0.01792
4	4	15100	876.00000	333.00000	3.00000	80.00000	3.00000	292.00000	333.00000	22.00000	4.06044	0.07317
5	5	15291	4623.30000	25.00000	14.00000	2102.00000	102.00000	45.32647	78.00000	29.00000	7.63675	0.04011
6	6	14688	5630.87000	7.00000	21.00000	3621.00000	327.00000	17.21979	48.00000	399.00000	8.07776	0.05722
7	7	17809	5411.91000	16.00000	12.00000	2057.00000	61.00000	88.71984	70.00000	41.00000	7.60887	0.03352
8	8	15311	60767.90000	0.00000	91.00000	38194.00000	2379.00000	25.54346	21.00000	474.00000	10.53795	0.24332
9	9	16098	2005.63000	87.00000	7.00000	613.00000	67.00000	29.93478	87.00000	0.00000	6.41836	0.02439

Last rows

	df_index	customer_id	gross_revenue	recency_days	purchases_quantity	basket_size	qt_products	avg_ticket	max_recency	purchased_returned_diff	frequency
5670	5761	21988	4839.42000	1.00000	1.00000	1074.00000	62.00000	78.05516	1.00000	6.97915	1.00000
5671	5762	13298	360.00000	1.00000	1.00000	96.00000	2.00000	180.00000	1.00000	4.56435	1.00000
5672	5763	14569	227.39000	1.00000	1.00000	79.00000	12.00000	18.94917	1.00000	4.36945	1.00000
5673	5764	21992	17.90000	1.00000	1.00000	14.00000	7.00000	2.55714	1.00000	2.63906	1.00000
5674	5765	21993	3.35000	1.00000	1.00000	2.00000	2.00000	1.67500	1.00000	0.69315	1.00000
5675	5766	21994	5699.00000	1.00000	1.00000	1747.00000	634.00000	8.98896	1.00000	7.46566	1.00000
5676	5767	21995	6756.06000	0.00000	1.00000	2010.00000	730.00000	9.25488	0.00000	7.60589	1.00000
5677	5768	21996	3217.20000	0.00000	1.00000	654.00000	59.00000	54.52881	0.00000	6.48311	1.00000
5678	5769	21997	3950.72000	0.00000	1.00000	731.00000	217.00000	18.20608	0.00000	6.59441	1.00000
5679	5770	12713	794.55000	0.00000	1.00000	505.00000	37.00000	21.47432	0.00000	6.22456	1.00000

Overview

Variables

Interactions

Correlations

Auto

Spearman's ρ

Pearson's r

Kendall's τ

Phik (φk)

Missing values

Sample

First rows

Last rows